package com.soil.code.generation.database.mysql.repository.mapper;

import com.mybatisflex.core.BaseMapper;
import com.soil.code.generation.database.mysql.repository.po.MysqlTableInfoPO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author zeno
 */
@Mapper
public interface MysqlTablesViewMapper extends BaseMapper<MysqlTableInfoPO>{

  /** 查询表名 */
  @Select(value = "select TABLE_NAME tableName,TABLE_COMMENT comment from information_schema.tables where TABLE_SCHEMA = #{schemaName}")
  List<MysqlTableInfoPO> findTableInfos(String schemaName );

}
